# coding: utf-8
from . import db, BaseModel


class Equipment(db.Model):
    __tablename__ = 'equipment'

    auto_id = db.Column(db.Integer, primary_key=True)
    equipment_id = db.Column(db.BigInteger, index=True, info='设备编号')
    equipment_name = db.Column(db.String(255), info='设备名称')
    picture = db.Column(db.LargeBinary, info='图片路径')
    count = db.Column(db.Integer, info='数量')
    description = db.Column(db.String(255), info='描述')
    is_delete = db.Column(db.Integer, server_default=db.FetchedValue())
    update_time = db.Column(db.DateTime, server_default=db.FetchedValue())
    create_time = db.Column(db.DateTime, server_default=db.FetchedValue())
